﻿	SELECT * 
	FROM LeagueMatch match
		LEFT JOIN LeagueTeamData teamData ON match.MatchID = teamData.MatchID
	WHERE teamData.MatchID IN
		(SELECT MatchID FROM LeagueMatch match 
		WHERE match.HomeTeamID = '2DE75E66-76F4-46CC-8FB7-63F98B922FC2'
		OR match.VisitingTeamID = '2DE75E66-76F4-46CC-8FB7-63F98B922FC2')
	ORDER BY match.MatchDateTime, teamData.MatchID



		SELECT * 
	FROM LeagueMatch match
		LEFT JOIN LeagueTeamData teamData ON match.MatchID = teamData.MatchID
	WHERE teamData.MatchID IN
		(SELECT MatchID FROM LeagueMatch match 
		WHERE match.HomeTeamID = '2DE75E66-76F4-46CC-8FB7-63F98B922FC2'
		OR match.VisitingTeamID = '2DE75E66-76F4-46CC-8FB7-63F98B922FC2')
	ORDER BY match.MatchDateTime, teamData.MatchID


	
EXEC LeagueTeamNameBatchInsert 'd2004489-6304-4b5c-90ad-a81d8887641b','安德莱赫特,阿贾克斯'